To define a sort and filter range, follow these steps:

1.Select the range of cells that will contain the data to be sorted and filtered.

2.Enable sorting and filtering in one of the following ways:

•On the Home tab, in the Data, click  Filter.

•On the Data tab, click  Filter.

•Right-click the selected range and select Filter from the context menu.

•Press Ctrl+Shift+L (Windows, Linux) or ⌘Cmd+⇧Shift+L (macOS).

A green frame is displayed around the active sorting and filtering range.

The top row of the range marked with , is not included in the filtering and sorting.